package com.miguo.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

import com.miguo.framework.utils.Log;

import de.greenrobot.dao.AbstractDaoMaster;
import de.greenrobot.dao.identityscope.IdentityScopeType;

public class DaoMaster extends AbstractDaoMaster {
    public static final int SCHEMA_VERSION = 10;

    /**
     * Creates underlying database table using DAOs.
     */
    public static void createAllTables(SQLiteDatabase db, boolean ifNotExists) {
        GoodsDao.createTable(db, ifNotExists);
        CategoryDao.createTable(db, ifNotExists);
        CategoryThemeDao.createTable(db, ifNotExists);
        CategoryBrandDao.createTable(db, ifNotExists);
        AdvertDao.createTable(db, ifNotExists);
        AddressDao.createTable(db, ifNotExists);
        ConfigDao.createTable(db, ifNotExists);
    }

    /**
     * Drops underlying database table using DAOs.
     */
    public static void dropAllTables(SQLiteDatabase db, boolean ifExists) {
        GoodsDao.dropTable(db, ifExists);
        CategoryDao.dropTable(db, ifExists);
        CategoryThemeDao.dropTable(db, ifExists);
        CategoryBrandDao.dropTable(db, ifExists);
        AdvertDao.dropTable(db, ifExists);
        AddressDao.dropTable(db, ifExists);
        ConfigDao.dropTable(db, ifExists);
    }

    public static abstract class OpenHelper extends SQLiteOpenHelper {

        public OpenHelper(Context context, String name, CursorFactory factory) {
            super(context, name, factory, SCHEMA_VERSION);
        }

        @Override
        public void onCreate(SQLiteDatabase db) {
            Log.i("Creating tables for schema version " + SCHEMA_VERSION);
            createAllTables(db, false);
        }
    }

    /**
     * WARNING: Drops all table on Upgrade! Use only during development.
     */
    public static class DevOpenHelper extends OpenHelper {
        public DevOpenHelper(Context context, String name, CursorFactory factory) {
            super(context, name, factory);
        }

        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
            Log.i("Upgrading schema from version " + oldVersion + " to " + newVersion + " by dropping all tables");
            dropAllTables(db, true);
            onCreate(db);
        }
    }

    public DaoMaster(SQLiteDatabase db) {
        super(db, SCHEMA_VERSION);
        registerDaoClass(GoodsDao.class);
        registerDaoClass(CategoryDao.class);
        registerDaoClass(CategoryThemeDao.class);
        registerDaoClass(CategoryBrandDao.class);
        registerDaoClass(AdvertDao.class);
        registerDaoClass(AddressDao.class);
        registerDaoClass(ConfigDao.class);
    }

    public DaoSession newSession() {
        return new DaoSession(db, IdentityScopeType.Session, daoConfigMap);
    }

    public DaoSession newSession(IdentityScopeType type) {
        return new DaoSession(db, type, daoConfigMap);
    }

}
